package cn.edu.lzu.dao;

import cn.edu.lzu.entity.ProfessionalTitle;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @PackageName: cn.edu.lzu.dao
 * @InterfaceName: ProfessionalTitle
 * @Description: TODO
 * @Author: 张琦[QQ:3098086691]
 * @Date: 2019/12/2 21:06
 * @Version: 1.0
 */
@Mapper
public interface ProfessionalTitleMapper {
    @Select("select * from professional_title group by professional_type")
    List<ProfessionalTitle> selAllProfessionalTypes();

    @Select("select * from professional_title where professional_type=#{professionalType}")
    List<ProfessionalTitle> selProfessionalTitlesByType(String professionalType);

    @Select("select * from professional_title where professional_title_id=#{professionalTitleId}")
    ProfessionalTitle selByProfessionalTitleId(long professionalTitleId);
}
